Re: autovacuum daemon question...

Поиск
Список
Период
Сортировка
От Jeff Bohmer
Тема Re: autovacuum daemon question...
Дата
Msg-id p06230914bf995bb6a436@[192.168.1.200]
обсуждение исходный текст
Ответ на Re: autovacuum daemon question...  (Jeff Bohmer <jdblist@visionlink.org>)
Список pgsql-admin
>AFAIK, a restart does not affect the VACUUMed-ness of anything.
>Keeping these (currently nonexistent autovacuum) stats across
>restarts would be helpful if stats_reset_on_server_start=on.


Sorry, got the meaning backwards.  The above should be
stats_reset_on_server_start=OFF.  And the below should be the
opposite, too.


>Unless I misunderstand, if stats_reset_on_server_start=off, these
>(currently nonexistent autovacuum) stats would only be relevant for
>autovacuum's VACUUM activity and not it's ANALYZE activity.


--

Jeff Bohmer
VisionLink, Inc.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Jeff Bohmer
Дата:
Сообщение: Re: autovacuum daemon question...
Следующее
От: FM
Дата:
Сообщение: backup restore of DB + LO